Skip to main content

Prerequisites

Following are the steps you need to perform to connect your data in Redshift.

  1. Set up a Redshift user with a unique username and password.

  2. Provide the Redshift user with read permissions for the specific tables, views, or schemas you wish to analyze with NetSpring.

  3. Enable case-sensitive lookup for databases, tables, and column names:

    ALTER USER <username> SET enable_case_sensitive_identifier = true

  4. Update the maximum query execution time to 5 minutes:

  • Navigate workgroup configuration.
  • Select Limits tab, and update the limit for “Maximum query execution time” from 14400s to 300s.

IP Whitelisting​

You also need to perform IP Whitelisting - following is the list of IPs that need to be whitelisted for NetSpring to access Redshift.

  • 3.215.188.76
  • 3.217.27.33
  • 3.233.246.20
  • 54.164.43.201
note
  • Whitelisting IPs is not a mandatory step. It is required only if the Redshift cluster is guarded by a security group (a firewall) that is preventing access to the cluster from NetSpring.